 package com.zhiyou.mapper;
import java.sql.Timestamp;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import com.zhiyou.model.FYStudyAttendance;
import com.zhiyou.model.FyClass;
@Repository
public interface TeacherManageMapper {

	
	//获取班级ID,以及时间,以及显示全部学生的考勤的次数
	List<FyClass> SelectByClassTID(@Param("class_id")Integer class_id,@Param("year")Integer year,@Param("month")Integer month);

	//根据学生ID显示考勤信息
	List<Map<String,String>> SelectByStudent(@Param("class_id")Integer class_id,@Param("current_date")Integer year,@Param("current_da")Integer month);

	//这是查学生考勤状况的
	List<Map<String,String>> SelectByStudentId(@Param("student_id")Integer student_id,@Param("current_date")Integer year,@Param("current_da")Integer month);
	//这是时间判断的详情页
	List<FYStudyAttendance> SelectByStudentIdTwo(@Param("student_id") Integer student_id,@Param("current_date")Integer year,@Param("current_da")Integer month);
	
	
	
	
	//根据学生姓名进行模糊查询
	List<Map<String,String>> selectByStudentName(@Param("student_name") String student_name);
	
	//请假
	void addone(@Param("student_id")Integer student_id,@Param("vacate_commit_time") Timestamp vacate_commit_time);

	void add(FYStudyAttendance fyStudyAttendance);
	
	//修改学生考勤
	void update(FYStudyAttendance fyStudyAttendance);
	
	//根据传过来的班级id获取班级总人数
	List<Map<String,String>> SelectSum(@Param("class_id") Integer class_id);
	
	//根据传过来的班级id获取班级未出勤人数
	List<Map<String,String>> SelectNCheck(@Param("class_id") Integer class_id);

	//智慧班牌的已出勤的展示
	List<Map<String,String>> SelectTure(@Param("class_id")Integer class_id);
	//智慧班牌的已出勤的展示
	List<Map<String,String>> SelectFalse(@Param("class_id")Integer class_id);
	
	//智慧班牌的模糊查询
	List<Map<String,String>> SelectMHOne(@Param("class_id")Integer class_id,@Param("student_name") String student_name);
	List<Map<String,String>> SelectMHTwo(@Param("class_id")Integer class_id,@Param("student_name") String student_name);
	
	
	
	
	
	
	
	
	
	
	
	
	
	
}
